package com.bgIntlgn.client.entity.warehourse;

import yuhuibear.poat.annotations.relation.View;
import yuhuibear.poat.object.bean.Bean;

/**
 * 零件的可用库存。
 * @author yuhui
 *
 */
@View(name = "avliable_stocks", sqlToCreate = "select us.uid as uid, (us.quantity - ps.total_quantity + ps.plan_quantity) as quantity "
		+ "from uid_stock_and_limit as us, producing_stocks as ps where us.uid = ps.uid")
public class AvaliableStock implements Bean {

	private String uid;
	private Long quantity;

	public String getUid() {
		return this.uid;
	}

	public void setUid(String uid) {
		this.uid = uid;
	}
	
	public Long getQuantity() {
		return quantity;
	}

	public void setQuantity(Long quantity) {
		this.quantity = quantity;
	}

}
